oracle sql 问题两道答:1.SELECT 顾客id ,SUM( DECODE( 航空公司, '东航', 1, 0 ) AS "乘坐东航次数",SUM( DECODE( 航空公司, '南航', 1, 0 ) AS "乘坐东航次数",SUM( DECODE( 航空公司, '北航', 1, 0 ) AS "乘坐东航次数"FROM 航空数据表 GROUP BY 顾客...
oracle sql 字符串拆分的查询的问题,急!!!答:CREATE TABLE A_TEST(id VARCHAR2(100),name VARCHAR2(100),t_desc VARCHAR2(100))insert into A_TEST values('1','zhansan','a,b,c');insert into A_TEST values('2','lisi','d,e,f');SELECT t.id,t.name,c.lv AS p,substr(t.ca,instr(t.ca, ',', 1, c.lv)...